# Frierson, Dylan, Lab 1
# 1
SELECT *
FROM books;
# 2
SELECT Title
FROM books;
# 3
SELECT Title, PubDate AS "Publication Date"
FROM books;
# 4
SELECT Customernum, City, State
FROM customers;
# 5
SELECT Name, Contact AS "Contact Person", Phone
FROM Publisher;
# 6
SELECT DISTINCT Category
FROM Books;
# 7
SELECT DISTINCT Customernum
FROM Orders;
# 8
SELECT Category, Title
FROM Books;
# 9
SELECT Fname, Lname
FROM Author;
# 10
SELECT Title, Retail - Cost AS "Profit"
FROM Books;